﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using QLT_Public;
using QLT_Data;
using System.Data;

namespace QLT_BLL
{
   public  class Thuoc_BLL
    {
       Thuoc_Data thuoc = new Thuoc_Data();
       public DataTable LayDuLieu()
       {
           return thuoc.LayDuLieu();
       }
       //lấy dữ liệu cho conmbobox đây nữa 
       public DataTable Load_Thuoc_BanThuoc()
       {
           return thuoc.Load_Thuoc_BanThuoc();
       }
       public DataTable taoBang(string sql)
       {
           return thuoc.TaoBang(sql);
       }
       public int insert_Thuoc(Thuoc_Public tenThuoc, Thuoc_Public tenNCC, Thuoc_Public maLoaiThuoc, Thuoc_Public soLuongTon, Thuoc_Public dVT,Thuoc_Public xuatXu, Thuoc_Public hanDung, Thuoc_Public tacDung, Thuoc_Public giaTien)
       {
           return thuoc.Insert_Thuoc(tenThuoc, tenNCC, maLoaiThuoc, soLuongTon,dVT, xuatXu, hanDung, tacDung, giaTien);
       }
       public int update_Thuoc(Thuoc_Public maThuoc, Thuoc_Public tenThuoc, Thuoc_Public tenNCC, Thuoc_Public maLoaiThuoc, Thuoc_Public soLuongTon,Thuoc_Public dVT, Thuoc_Public xuatXu, Thuoc_Public hanDung, Thuoc_Public tacDung, Thuoc_Public giaTien)
       {
           return thuoc.Update_Thuoc(maThuoc,tenThuoc, tenNCC, maLoaiThuoc, soLuongTon, dVT,xuatXu, hanDung, tacDung, giaTien);
       }
       public int update_Thuoc_SoLuongTon(Thuoc_Public maThuoc, Thuoc_Public soLuongTon)
       {
           return thuoc.update_Thuoc_SoLuongTon(maThuoc,soLuongTon);
       }
       public int update_Thuoc_SoLuongBan(Thuoc_Public maThuoc, Thuoc_Public soLuongTon)
       {
           return thuoc.update_Thuoc_SoLuongBan(maThuoc,soLuongTon);
       }
       public int delete_Thuoc(Thuoc_Public maThuoc)
       {
           return thuoc.Delete_Thuoc(maThuoc);
       }
       public DataTable Load_TimKiem_Thuoc()
       {
           return thuoc.Load_TimKiem_Thuoc();
       }
       public DataTable TimKiem_TenThuoc(Thuoc_Public tenThuoc)
       {
           return thuoc.TimKiem_TenThuoc(tenThuoc);
       }
       public DataTable TimKiem_LoaiThuoc_GiaTien(LoaiThuoc_Public tenLoaiThuoc, int soDau, int soCuoi)
       {
           return thuoc.TimKiem_LoaiThuoc_GiaTien(tenLoaiThuoc,soDau,soCuoi);
       }
       public DataTable TimKiem_TenLoaiThuoc(LoaiThuoc_Public tenloaiThuoc)
       {
           return thuoc.TimKiem_TenLoaiThuoc(tenloaiThuoc);
       }
       public DataTable TimKiem_TenThuoc_GiaTien(Thuoc_Public tenThuoc, int soDau, int soCuoi)
       {
           return thuoc.TimKiem_TenThuoc_GiaTien(tenThuoc,soDau,soCuoi);
       }
       public DataTable TimKiem_TenThuoc_LoaiThuoc(Thuoc_Public tenThuoc, LoaiThuoc_Public tenLoaiThuoc)
       {
           return thuoc.TimKiem_TenThuoc_TenLoaiThuoc(tenThuoc,tenLoaiThuoc);
       }
       public DataTable TimKiem_GiaTien(int soDau, int soCuoi)
       {
           return thuoc.TimKiem_GiaTien(soDau,soCuoi);
       }
       public DataTable TimKiem_TenThuoc_LoaiThuoc_GiaTien(Thuoc_Public tenThuoc, LoaiThuoc_Public tenLoaiThuoc, int soDau, int soCuoi)
       {
           return thuoc.TimKiem_TenThuoc_LoaiThuoc_GiaTien(tenThuoc,tenLoaiThuoc, soDau,soCuoi);
       }
       public DataTable TimKiem_Thuoc_BanThuoc(Thuoc_Public tenthuoc)
       {
           return thuoc.TimKiem_Thuoc_BanThuoc(tenthuoc);
       }
    }
}
